# Query Description # Type of request: Extract data from a table # Name of the selected table: sophie # Description of the table: Spectra # Restrict with the SQL clause: (dec between -1 and 1) AND (sn26 > 250) # Description of each column # $link[objname]: ------ Designation of the object # $j2000: -------------- J2000 coordinates # $link['S']: ---------- Link to Simbad database # $link['E']: ---------- # seq: ----------------- Sequence number # $link[slen]: --------- Length of the series # date: ---------------- Calendar date of observation # mode: ---------------- Observation mode: High resolution or High efficiency # fiber_b: ------------- Use of the second fiber (DARK, WAVE or SKY) # exptime: ------------- exposure time # sn26: ---------------- Signal/noise in order 26 # $link[view_spec]: ---- # $link[view_head]: ---- # $link[get_spec]: ----- # $link[get_e2ds]: ----- # $link[customize]: ---- # $link[search_ccf]: --- #-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- #$link[objname] $j2000 $li $li seq $lin date mode fibe exptim sn2 $link[vie $link[vie $link[ge $link[ge $link[cus $link[sear # nk[ nk[ k[sl r_b e 6 w_spec] w_head] t_spec] t_e2ds] tomize] ch_ccf] # 'S' 'E' en] # ] ] #-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ---------- HD022484 J033652.4+002406 S E 1918550 1 2016-01-25 HR WAVE 240.0 316 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1883070 2 2015-10-20 HR WAVE 240.0 252 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1881790 2 2015-10-16 HR WAVE 240.0 321 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1887450 2 2015-11-18 HR WAVE 240.0 283 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1887460 2 2015-11-18 HR WAVE 240.0 303 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1919710 2 2016-01-29 HR WAVE 250.0 289 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1919720 2 2016-01-29 HR WAVE 250.0 273 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2092510 1 2017-01-21 HR WAVE 240.0 380 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2013900 2 2016-08-14 HR WAVE 240.0 347 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2013890 2 2016-08-14 HR WAVE 240.0 336 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1868230 1 2015-09-18 HR WAVE 240.0 275 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1868690 1 2015-09-19 HR WAVE 240.0 259 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1868680 1 2015-09-19 HR WAVE 240.0 255 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1869770 2 2015-09-21 HR WAVE 240.0 271 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1869760 2 2015-09-21 HR WAVE 240.0 298 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1869150 2 2015-09-20 HR WAVE 240.0 286 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1869140 2 2015-09-20 HR WAVE 240.0 273 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1867720 2 2015-09-17 HR WAVE 240.0 270 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2012530 1 2016-08-11 HR WAVE 240.0 261 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2096140 2 2017-01-29 HR WAVE 240.0 298 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2096110 2 2017-01-29 HR WAVE 240.0 288 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1881800 2 2015-10-16 HR WAVE 240.0 313 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1886591 1 2015-11-16 HR WAVE 240.0 348 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1886601 1 2015-11-16 HR WAVE 240.0 299 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2092500 1 2017-01-21 HR WAVE 240.0 339 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2096150 2 2017-01-29 HR WAVE 240.0 292 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 2091130 1 2017-01-19 HR WAVE 240.0 267 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1700361 1 2014-09-25 HR WAVE 240.0 296 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1700351 1 2014-09-25 HR WAVE 240.0 266 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1700951 1 2014-09-26 HR WAVE 240.0 372 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1758210 2 2015-01-14 HR WAVE 300.0 316 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1758220 2 2015-01-14 HR WAVE 300.0 253 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1757760 2 2015-01-13 HR WAVE 300.0 322 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1723091 2 2014-11-07 HR WAVE 240.0 273 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1723081 2 2014-11-07 HR WAVE 240.0 256 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1723190 2 2014-11-07 HR WAVE 300.0 307 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1723200 2 2014-11-07 HR WAVE 300.0 296 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1723261 2 2014-11-07 HR WAVE 250.0 277 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1723271 2 2014-11-07 HR WAVE 250.0 273 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1722390 1 2014-11-06 HR WAVE 250.0 255 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1722401 1 2014-11-06 HR WAVE 250.0 269 view_spec view_head get_spec get_e2ds customize search_CCF HD022484 J033652.4+002406 S E 1700961 1 2014-09-26 HR WAVE 240.0 370 view_spec view_head get_spec get_e2ds customize search_CCF HD097585 J111345.6-000410 S E 308590 1 2007-02-13 HR DARK 840.0 301 view_spec view_head get_spec get_e2ds customize search_CCF HD097585 J111345.6-000410 S E 310790 1 2007-02-15 HR DARK 804.6 401 view_spec view_head get_spec get_e2ds customize search_CCF MOON J114300.0+003500 S E 375170 1 2007-05-25 HR DARK 300.0 696 view_spec view_head get_spec get_e2ds customize search_CCF HD181555 J192056.4+005454 S E 387510 2 2007-06-16 HE DARK 900.0 260 view_spec view_head get_spec get_e2ds customize search_CCF HD181555 J192056.4+005454 S E 392000 2 2007-06-23 HE DARK 900.0 252 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968110 1 2010-06-25 HR WAVE 600.0 292 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966250 1 2010-06-22 HR WAVE 500.0 273 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966740 1 2010-06-23 HR WAVE 600.0 279 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968590 1 2010-06-26 HR WAVE 600.0 265 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 969200 1 2010-06-27 HR WAVE 600.0 259 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966220 1 2010-06-22 HR WAVE 500.0 263 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966800 1 2010-06-23 HR WAVE 400.0 263 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968080 1 2010-06-25 HR WAVE 600.0 297 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968530 1 2010-06-26 HR WAVE 600.0 272 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968490 1 2010-06-26 HR WAVE 600.0 274 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 965600 1 2010-06-21 HR WAVE 600.0 274 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 969170 1 2010-06-27 HR WAVE 600.0 255 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968050 1 2010-06-25 HR WAVE 600.0 253 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966860 1 2010-06-23 HR WAVE 400.0 283 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966770 1 2010-06-23 HR WAVE 400.0 266 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 968140 1 2010-06-25 HR WAVE 600.0 310 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 966160 1 2010-06-22 HR WAVE 600.0 323 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 967480 1 2010-06-24 HR WAVE 600.0 282 view_spec view_head get_spec get_e2ds customize search_CCF HD181907 J192221.6-001509 S E 967450 1 2010-06-24 HR WAVE 600.0 296 view_spec view_head get_spec get_e2ds customize search_CCF HD187929 J195228.4+010020 S E 1673020 1 2013-10-07 HR SKY 180.0 317 view_spec view_head get_spec get_e2ds customize search_CCF HD187929 J195228.4+010020 S E 1672670 1 2013-10-06 HR SKY 180.0 274 view_spec view_head get_spec get_e2ds customize search_CCF #-- end of data table ---------------------------------------------------------- # 68 lines were successfully retrieved